SUPPORT / SAMPLES & SAS NOTES
Usage Note 65885: The ability to connect to a Google BigQuery database via OAuth Authentication has been added to SAS/ACCESS® Interface to Google BigQuery
 |  |  |  |  |
The ability to connect to a Google BigQuery database via OAuth is now available with this hot fix. Three new options have been added, REFRESH_TOKEN=, CLIENT_ID=, and CLIENT_SECRET=. You can use these options with the following connection methods to the Google BigQuery database:
LIBNAME GBQ BIGQUERY REFRESH_TOKEN="<token>" CLIENT_ID="<client_id>" CLIENT_SECRET=<client_secret> ...;
PROC SQL; CONNECT TO BIGQUERY(REFRESH_TOKEN="<token>" CLIENT_ID="<client_id>" CLIENT_SECRET=<client_secret> ...);
PROC FEDSQL NOLIB CONN=(DRIVER=FEDSQL;CONOPTS=(DRIVER=BIGQUERY;REFRESH_TOKEN="<token>"; CLIENT_ID="<client_id>";CLIENT_SECRET=<client_secret>;...));
CASLIB GBQ DATASOURCE=(srctype="bigquery", REFRESH_TOKEN="<token>",CLIENT_ID="<client_id>",CLIENT_SECRET="<client_secret>" ,...);
A utility has been created to generate the refresh token that is needed for OAuth authentication. This utility can be downloaded from the SAS/ACCESS to Google BigQuery Tools Downloads page. The ReadME file contains a link to usage information about the getRefreshToken utility.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.42 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.05 | 2020.1.1 | Viya | Viya |